1 CREATE SEQUENCE content_content_id_seq
;
2 CREATE TABLE &mw_prefix.
content (
3 content_id
NUMBER NOT NULL,
4 content_size
NUMBER NOT NULL,
5 content_sha1
VARCHAR2(32) NOT NULL,
6 content_model
NUMBER NOT NULL,
7 content_address
VARCHAR2(255) NOT NULL
10 ALTER TABLE &mw_prefix.
content ADD CONSTRAINT &mw_prefix.content_pk
PRIMARY KEY (content_id
);
13 CREATE TRIGGER &mw_prefix.content_seq_trg
BEFORE INSERT ON &mw_prefix.
content
14 FOR EACH ROW WHEN (new.content_id
IS NULL)
16 &mw_prefix.lastval_pkg.
setLastval(content_content_id_seq.nextval
, :new.content_id
);